Copyright: Copyright © 2000 Elevate Software
Citation: Copyright © 2000 Elevate Software


Performing Actions on Tables and Query Result Sets

All options available on the Action sub-menu of the main menu and also the Print option on the File sub-menu are only available when a table or query result set is open and always only apply to the topmost table or query result set opened. The exception to this is the Print option, which allows you to print both structures and listings of all open tables and query result sets.


Multiple Selections in Table Open and Save Dialogs

All of the dialogs in the Database System Utility used to open, select, save, or create tables allow for multiple selections. To take advantage of this feature just simply hold down the CTRL key and click on the desired table names in the dialog or hold down the SHIFT key and select the first and last table names in a range of table names that you wish to select.


Opening Tables Exclusively

You should be very careful when opening up tables exclusively that are used in another shared application on a network. Doing this may block out other applications from opening up the table at all and may cause unnecessary confusion. A better solution, if you need to make sure that no one else modifies the table, is to open the table in shared mode and then lock the entire table so that others can open and read from the table but not modify it.


Record Numbers

The record numbers displayed at the bottom of the Database System Utility when a table is open will vary in behavior depending upon whether an active range, filter, or both, exists. Record numbers in DBISAM are "logical" record numbers, meaning they differ for any given physical record depending upon the active index.

When a range is in effect the logical record numbers will start at the first record in the range and continue until the last record in the range is reached. For example, if a range is set that causes only 3000 records to be visible, then record number 100 will be the 100th record in the range according to the active index.

When a filter is in effect the logical records will still start at the first record in the table and continue until the last record in the table is reached. However, if a record does not fall into the current filter then that record number will be "skipped" in the sequence of record numbers according to the active index. For example, if a filter is set that causes records 100-103 to not be visible, then navigating past record number 99 will cause the record number to skip to the 104th record.

When a range and a filter are in effect the logical records will still start at the first record in the range and continue until the last record in the range is reached. However, if a record does not fall into the current filter then that record number will be "skipped" in the sequence of record numbers according to the active index. For example, if a range is set that causes only 200 records to be visible and a filter is set that causes records 100-103 to not be visible, then navigating past record number 99 will cause the record number to skip to the 104th record in the current range.


Record Counts

Record counts are always accurate, regardless of whether a range, filter, or both are active. This can sometimes cause some confusing results because the record number when a filter is active is based on either the total records in the table or the total records visible in the active range while the record count reflects the total number of records present in the active filter. For example, if a filter is active (but no ranges are active) the record number may show 10005 and the record count may show 100. What this means is that the current record is the 10005 record in the table according to the active index and there are only 100 records currently visible due to the active filter.


Restructure Backup Data

Using the Restructure option of the Database System Utility will cause a backup of the table being restructured to be created in all cases except when identifiers such as the table description, field names, or index names are simply being renamed. The backup file names have the same root as the original file name but with a different extension. The following table lists the backup file extensions:

Extension	Description

Tables (.DAT)	The backup extension for tables is .DBK

Index Files (.IDX)	The backup extension for index files is .IBK

Blob Files (.BLB)	The backup extension for blob files is .BBK

All of these files can be restored by simply renaming them with the proper .DAT, .IDX, or .BLB extension.


Upgrade Backup Data

Using the Upgrade option of the Database System Utility will cause a backup of the table being upgraded to be created. The backup file names have the same root as the original file name but with a different extension. The following table lists the backup file extensions:

Extension	Description

Tables (.DAT)	The backup extension for tables is .DUP

Index Files (.IDX)	The backup extension for index files is .IUP

Blob Files (.BLB)	The backup extension for blob files is .BUP

All of these files can be restored by simply renaming them with the proper .DAT, .IDX, or .BLB extension.


Empyting, Copying, Renaming, Deleting Tables

All of these operations in the Database System Utility are irreversable, so please be extremely careful when using them. The Database System Utility will prompt you to make sure that you want to execute the desired operation, and will allow you to cancel the operation if desired. Still, it's very important that you use the utmost care in making sure that you have backups of your tables before executing any of these operations. Elevate Software cannot be held responsible for improper use of these operations.


Main Status
This status panel will show the hints for menu items as you move the mouse over them and will also show the current state of the topmost open table or query result set.


Open Mode Status
This status panel will show the current open mode of the topmost open table or query result set. The following list indicates the possible indicators for this status panel:

Tables

The table is opened in shared mode and is read-only

The table is opened in shared mode and is editable

The table is opened in exclusive mode and is read-only

The table is opened in exclusive mode and is editable

Query Input

The query input page is the active page and the text will indicate whether the query is prepared or unprepared

Query Result Sets

The query result set is open (the result set page is the active page) and cannot be edited (is a canned result set)

The query result is open (the result set page is the active page) and can be edited (is a live result set)


Index Status
This status panel will show the active index of the topmost open table.


Filter Status
This status panel will show if a filter is currently active for the topmost open table or query result set. The following list indicates the possible indicators for this status panel:

There is no filter active for the table

There is a filter active for the current table and it is completely non-optimizable (slowest)

There is a filter active for the current table and it is only partially optimizable (semi-fast)

There is a filter active for the current table and it is completely optimizable (fastest)


Range Status
This status panel will show if a range is currently active for the topmost open table. The following list indicates the possible indicators for this status panel:

There is no range active for the table

There is an active range for the table


Record Status
This status panel will show the record number and record count for the topmost open table or query result set.


Lock Status
This status panel will show if the current record is locked for the topmost open table or query result set. The following list indicates the possible indicators for this status panel:

The current record is not locked

The current record is locked


Program Icon
The program icon for the Database System Utility.


Version Information
The version information for the Database System Utility.


About Close
Click on this button to close the About box.


Browse Browse Tab
This page of the browse window shows the actual data contents in the table and the date and time of the last update. You can select which fields are visible using the Select Visible Fields button.


Browse Visible Fields
Click on this button to bring forward a dialog that will let you select which fields are visible for the table. Please note that all import and export operations only work on the visible fields, so you can use this option to control which fields are exported and which fields are available in an imported file.


Browse Last Update
This read-only information shows the date and time of the last update to the table. You can update this information by clicking on the Refresh button on the main data navigator at the top of the main window.


Browse Grid
This grid shows the contents of the table. You can edit or view any memo, graphic, or generic BLOB fields by simply double-clicking on the desired field in the desired record. A memo, graphic, or generic BLOB field contains data if the contents label ("(MEMO)", "(GRAPHIC)", or "(BLOB)") are upper-cased. If the contents label is not upper-cased ("(Memo)", "(Graphic)", or "(Blob)") then the field does not contain any data. The fields that are visible in this grid are controlled by the Select Visible Fields button.


Browse Structure Tab
This page of the browse window shows the structure of the table. You can find out detailed information regarding any field by selecting the desired field and clicking on the Details button available in the Details column on the right hand side of the grid. Clicking on this button will open a dialog with detail information for the currently selected field in the field structure grid. The information that is shown in this dialog includes the field description, default value, minimum value, maximum value, and character-casing.


Browse Secondary Indexes
This page of the browse window shows the secondary index of the table. The primary index information for the table is shown on the Structure page of the browse window.


Browse Structure Description
This read-only information shows the description of the table.


Browse Structure Encrypted
This read-only information indicates whether the table is encrypted.


Browse Structure Password
This read-only information always shows "Password Not Shown" if the table is encrypted, or blank if the table is not encrypted.


Browse Structure Grid
This read-only grid shows the field structure and primary index fields information for the table.


Browse Structure FieldCount
This read-only information shows the number of fields defined in the table.


Browse Structure RecordSize
This read-only information shows the total record size for the table.


Browse Structure BlockSize
This read-only information shows the BLOB block size for the table.


Browse Structure PrimaryDesc
This read-only information shows whether the primary index is descending.


Browse Secondary Count
This read-only information shows the number of secondary indexes defined for the table.


Browse Secondary Grid
This read-only grid shows the secondary indexes defined for the table.


Browse FieldDescription
This read-only information shows the description for the currently selected field.


Browse DefaultValue
This read-only information shows the default value for the currently selected field.


Browse MinValue
This read-only information shows the minimum value for the currently selected field.


Browse MaxValue
This read-only information shows the maximum value for the currently selected field.


Browse Close
Click on this button to close the field details dialog and return to the browse window for the table.


Filter AvailableFields
This listbox shows the available fields for filtering. Any fields that can be optimized using an available index are indicated by an [Optimized] to the right of the field name. To add a field to the filter expression simply double-click on the desired field name.


Filter RelationalOperators
This listbox shows the available relational operatiors for filtering. To add a relational operator to the filter expression simply double-click on the desired relational operator.


Filter LogicalOperators
This listbox shows the available logical operatiors for filtering. To add a logical operator to the filter expression simply double-click on the desired logical operator.


Filter Expression
This memo control is used to specify the filter expression to be used for filtering the topmost table or query result set. You have the option of selecting fields, relational operators, and logical operators from the list boxes provided or simply typing in the desired filter expression in this memo control. If the filter expression entered is not correct or contains a syntax error you will receive an appropriate message when attempting to set the filter by clicking on the Set button.


Filter Options
Use these check boxes to specify additional information about how the current filter expression should be processed. If you do not want partial comparisons to be allowed by using the wildcard (*) character then you should click on the No Partial Comparions check box. If you want any comparisons done on string fields to be case-insensitive then you should click on the Case-Insensitive check box. Please note that changing the Case-Insensitive option can affect the optimizability of the current filter expression. Only indexes that are marked as case-insensitive are available for use in optimizations in string field comparisons when you check the case-insensitive option. Also note that only string field comparisons are affected by both the partial comparisons option and the case-insensitive option - all other field type comparisons ignore these options.


Filter Set
Click on this button to set the current filter expression and apply it to the topmost table or query result set. Depending upon the optimizability of the filter expression and the number of records in the topmost table or query result set this process can range in execution time from instantaneous to several minutes. Also, at this point you will be notified of any errors that are present in the filter expression and will be given the opportunity to correct them.


Filter Clear
Click on this button to clear the current filter expression and remove it from the topmost table or query result set.


Filter Cancel
Click on this button to cancel setting or clearing the current filter expression and return to the topmost table or query result set browse window.


Find AvailableFields
This listbox shows the available fields for finding a record. Any fields that can be optimized using an available index are indicated by an [Optimized] to the right of the field name. To add a field to the find expression simply double-click on the desired field name.


Find RelationalOperators
This listbox shows the available relational operatiors for finding a record. To add a relational operator to the find expression simply double-click on the desired relational operator.


Find LogicalOperators
This listbox shows the available logical operatiors for finding a record. To add a logical operator to the find expression simply double-click on the desired logical operator.


Find Expression
This memo control is used to specify the find expression to be used for finding a record in the topmost table or query result set. You have the option of selecting fields, relational operators, and logical operators from the list boxes provided or simply typing in the desired find expression in this memo control. If the find expression entered is not correct or contains a syntax error you will receive an appropriate message when attempting to find a record by clicking on the First, Prior, Next, or Last buttons.


Find Options
Use these check boxes to specify additional information about how the current find expression should be processed. If you do not want partial comparisons to be allowed by using the wildcard (*) character then you should click on the No Partial Comparions check box. If you want any comparisons done on string fields to be case-insensitive then you should click on the Case-Insensitive check box. Please note that changing the Case-Insensitive option can affect the optimizability of the current find expression. Only indexes that are marked as case-insensitive are available for use in optimizations in string field comparisons when you check the case-insensitive option. Also note that only string field comparisons are affected by both the partial comparisons option and the case-insensitive option - all other field type comparisons ignore these options.


Find First
Click on this button to find the first record in the topmost table or query result set that matches the current find expression. Depending upon the optimizability of the find expression and the number of records in the topmost table or query result set this process can range in execution time from instantaneous to several minutes. Also, at this point you will be notified of any errors that are present in the find expression and will be given the opportunity to correct them. Please note that using this option will clear any active filter expression already set on the topmost table or query result set.


Find Prior
Click on this button to find the prior record (based upon the current record position) in the topmost table or query result set that matches the current find expression. Depending upon the optimizability of the find expression and the number of records in the topmost table or query result set this process can range in execution time from instantaneous to several minutes. Also, at this point you will be notified of any errors that are present in the find expression and will be given the opportunity to correct them. Please note that using this option will clear any active filter expression already set on the topmost table or query result set.


Find Next
Click on this button to find the next record (based upon the current record position) in the topmost table or query result set that matches the current find expression. Depending upon the optimizability of the find expression and the number of records in the topmost table or query result set this process can range in execution time from instantaneous to several minutes. Also, at this point you will be notified of any errors that are present in the find expression and will be given the opportunity to correct them. Please note that using this option will clear any active filter expression already set on the topmost table or query result set.


Find Last
Click on this button to find the last record in the topmost table or query result set that matches the current find expression. Depending upon the optimizability of the find expression and the number of records in the topmost table or query result set this process can range in execution time from instantaneous to several minutes. Also, at this point you will be notified of any errors that are present in the find expression and will be given the opportunity to correct them. Please note that using this option will clear any active filter expression already set on the topmost table or query result set.


Find Cancel
Click on this button to cancel finding a record and return to the topmost table or query result set browse window.


GotoRecord Number
Enter in the logical record number you wish to move to. Please note that the logical record number is dependent upon any active ranges or filters.


GotoRecord Go
Click on this button to move to the desired logical record number and return to the topmost table or query result set browse window. If the desired logical record number cannot be found then the record pointer will be positioned on the next closest logical record number.


GotoRecord Cancel
Click on this button to cancel the logical record move and return to the topmost table or query result set browse window.


Graphic Image
This control shows the graphic image (bitmap) for the current field in the topmost table or query result set. You can cut, copy, or paste this graphic image in order to change it or use the Import or Export buttons to read a new graphic image from a file or save the graphic image to a file.


Graphic DisplayOptions
Use these check boxes to specify how the current graphic image should be displayed. The Center Graphic option is used to center the graphic within the graphic control. The Stretch Graphic option is used to stretch the graphic to fit the entire area of the graphic control. Please note that the Stretch Graphic option has no effect upon icon (ICO) images. The Quick Draw option is used to indicate whether the graphic image is displayed using a palette. If not checked, a palette is used to provide the best possible image quality at the expense of additional processing time. If checked, no special palette is used, which is faster, but results in poorer picture quality, especially with 256-color images on a 256-color video driver.


Graphic Size
This read-only information indicates the size of the current graphic image in bytes.


Graphic Import
Click on this button to bring forward a standard Windows open dialog that will allow you select a graphic file to import into the current field in the topmost table or query result set. You may import bitmap (BMP) images only.


Graphic Export
Click on this button to bring forward a standard Windows save dialog that will allow you select a graphic file to export the current field into.


Graphic Close
Click on this button to close the current graphic dialog and return to the topmost table or query result set browse window.


Memo Text
This control shows the memo text for the current field in the topmost table or query result set. You can cut, copy, or paste this text in order to change it or use the Import or Export buttons to read new text from a file or save the text to a file.


Memo_DisplayOptions
Use these check boxes to specify how the current memo text should be displayed. The Want Tabs option is used to specify whether tabs can be entered into the current memo text within the memo control. Please note that when this option is enabled you will not be able to use the TAB key to move out of the memo control. The Word Wrap option is used to wrap lines of text when they extend beyond the right border of the memo control.


Memo Size
This read-only information indicates the size of the current memo text in bytes.


Memo Import
Click on this button to bring forward a standard Windows open dialog that will allow you select a text file to import into the current field in the topmost table or query result set.


Memo Export
Click on this button to bring forward a standard Windows save dialog that will allow you select a text file to export the current field into.


Memo Close
Click on this button to close the current memo dialog and return to the topmost table or query result set browse window.


Visible AvailableFields
This listbox shows the available fields for the topmost table or query result set that are currently not visible. You may drag fields from this listbox and drop them in the Visible Fields listbox in order to make them visible. You may also drag fields from the Visible Fields listbox and drop them in this listbox in order to make them non-visible, or drag and drop fields within this listbox to move them into different positions. This listbox fully supports multiple selection of fields by holding down the CTRL key and clicking on the desired fields or by holding down the SHIFT key and clicking on the first and last fields in the desired range of fields.


Visible VisibleFields
This listbox shows the visible fields for the topmost table or query result set. You may drag fields from this listbox and drop them in the Available Fields listbox in order to make them non-visible. You may also drag fields from the Available Fields listbox and drop them in this listbox in order to make them visible, or drag and drop fields within this listbox to move them into different positions. This listbox fully supports multiple selection of fields by holding down the CTRL key and clicking on the desired fields or by holding down the SHIFT key and clicking on the first and last fields in the desired range of fields.


Visible MoveOne
Click on this button to move the currently selected fields in the Available Fields listbox into the Visible Fields listbox.


Visible MoveAll
Click on this button to move all of the fields in the Available Fields listbox into the Visible Fields listbox regardless of what fields are selected in the Available Fields listbox.


Visible RemoveOne
Click on this button to move the currently selected fields in the Visible Fields listbox into the Available Fields listbox.


Visible RemoveAll
Click on this button to move all of the fields in the Visible Fields listbox into the Available Fields listbox regardless of what fields are selected in the Visible Fields listbox.


Visible OK
Click on this button to make the visible field selections in this dialog active and return to the topmost table or query result set browse window.


Visible Cancel
Click on this button to cancel the visible field selection and return to the topmost table or query result set browse window.


Secondary AvailableFields
This listbox shows the available fields for the table that are currently not part of the secondary index being defined. You may drag fields from this listbox and drop them in the Index Fields listbox in order to make them part of the secondary index. You may also drag fields from the Index Fields listbox and drop them in this listbox in order to remove them from the secondary index, or drag and drop fields within this listbox to move them into different positions. This listbox fully supports multiple selection of fields by holding down the CTRL key and clicking on the desired fields or by holding down the SHIFT key and clicking on the first and last fields in the desired range of fields.


Secondary IndexFields
This listbox shows the index fields for the table that are currently part of the secondary index being defined. You may drag fields from this listbox and drop them in the Available Fields listbox in order to remove them from the secondary index. You may also drag fields from the Available Fields listbox and drop them in this listbox in order to make them part of the secondary index, or drag and drop fields within this listbox to move them into different positions within the secondary index. This listbox fully supports multiple selection of fields by holding down the CTRL key and clicking on the desired fields or by holding down the SHIFT key and clicking on the first and last fields in the desired range of fields.


Secondary MoveOne
Click on this button to move the currently selected fields in the Available Fields listbox into the Index Fields listbox.


Secondary MoveAll
Click on this button to move all of the fields in the Available Fields listbox into the Index Fields listbox regardless of what fields are selected in the Available Fields listbox.


Secondary RemoveOne
Click on this button to move the currently selected fields in the Index Fields listbox into the Available Fields listbox.


Secondary RemoveAll
Click on this button to move all of the fields in the Index Fields listbox into the Available Fields listbox regardless of what fields are selected in the Index Fields listbox.


Secondary_OK
Click on this button to complete the secondary index field selections in this dialog for the current secondary index being defined and return to the secondary index keys page of the structure dialog.


Secondary Cancel
Click on this button to cancel the secondary index field selection and return to the secondary index keys page of the structure dialog.


Options DefaultDatabase
Use this combo box to specify the default database directory for the Database System Utility. You may click on the drop-down button of the combo box in order to select from a history list of the most recently used directories. The default database directory is used as the default directory when opening, creating, renaming, copying, deleting, emptying, repairing, etc. tables and is also used as the default database directory for any SQL query.


Options DefaultSelect
Click on this button to bring forward a standard Windows directory selection dialog and select the default database directory for the Database System Utility. The default database directory is used as the default directory when opening, creating, renaming, copying, deleting, emptying, repairing, etc. tables and is also used as the default database directory for any SQL query.


Options PrivateDirectory
Use this combo box to specify the private directory for the Database System Utility. You may click on the drop-down button of the combo box in order to select from a history list of the most recently used directories. The private directory is used for any temporary tables created during processing such as query result sets.


Options PrivateSelect
Click on this button to bring forward a standard Windows directory selection dialog and select the private directory for the Database System Utility. The private directory is used for any temporary tables created during processing such as query result sets.


Options LockRetry
Use this edit box to enter the default lock retry count used for all table and query operations within the Database System Utility. The lock retry count may be any value from 0 to 255. A higher setting allows for more lock retries before the user is notified of a lock failure. This lock retry count applies to both record locks and file locks.


Options LockWait
Use this edit box to enter the default lock retry wait time used for all table operations within the Database System Utility. The lock retry wait time is specified in milliseconds may be any value from 0 to 65535. A higher setting allows for more time between lock retries and extends the time spent retrying a lock before the user is notified of a lock failure. This lock retry wait time applies to both record locks and file locks.


Options Override Table
This check box is used to specify whether date, time, and numeric data should be shown in the display format appropriate for the language ID and sort ID defined for the table or query result set. For example, if the topmost table window is using the German (Standard) language ID and this option is checked, then all numbers will require the use of the ',' (comma) character as a decimal separator instead of a '.' (period) character. If this check box is not checked then the Database System Utility will use the default language ID and sort ID defined in the Options dialog for displaying date, time, and numeric data.


Options Passwords
Click on this button to open up the standard password maintenance dialog and add and remove table passwords for the current Database System Utility session. All table passwords are stored in memory and are only available for the current session. Exiting the Database System Utility will remove all previously-entered table passwords.


Options OK
Click on this button to save the current options (everything except for the current table passwords which are only available for the current session) and return to the main window of the Database System Utility.


Options Cancel
Click on this button to cancel any changes made to the options and return to the main window of the Database System Utility.


Print OutputType
Use these radio buttons to select what you would like to print for the topmost table or query result set. You may print the structure of the topmost table or a listing of the contents of the topmost table or query result set. The listing option is affected by the visible fields selection for the topmost table or query result set as well as any ranges or filters that may be active. Please be careful when using the listing option with large tables or query result sets since an extremely large number of pages in the printed listing may result.


Print Option
Use these radio buttons to select whether you want to print a structure or listing for the topmost table or query result set only or for all open tables and query result sets.


Print Print
Click on this button to begin printing using the selected output type and options and return to the topmost table or query result set browse window.


Print Setup
Click on this button to bring forward the standard Windows printer setup dialog and change the printer settings.


Print Cancel
Click on this button to cancel printing and return to the topmost table or query result set browse window.


Range BeginValues
Use this grid to enter the beginning key field values of the range. Only the fields that are part of the current active index will be shown in this grid. You may choose to enter only part or none of the key field values.


Range EndValues
Use this grid to enter the ending key field values of the range. Only the fields that are part of the current active index will be shown in this grid. You may choose to enter only part or none of the key field values.


Range Set
Click on this button to set the current range and apply it to the topmost table. This process is always instantaneous and you will be notified if any of the key field values entered are invalid for the associated field.


Range Clear
Click on this button to clear the current range and remove it from the topmost table.


Range Cancel
Click on this button to cancel setting or clearing the current range and return to the topmost table browse window.


Reverse Directory
Use this edit box to specify the directory to use as the database directory for each table created.


Reverse Select
Click on this button to bring forward a standard Windows directory selection dialog and select the directory to be used as the database directory for each table created.


Reverse Continue
Click on this button to continue with the reverse engineering process for the selected table(s).


Reverse Cancel
Click on this button to cancel the reverse engineering process and return to the main window of the Database System Utility.


Search Options
Use this check box to specify whether the record pointer should be positioned on the next closest match if the currently entered key field values are not found in the topmost table.


Search FieldValues
Use this grid to enter the key field values for the range. Only the fields that are part of the current active index will be shown in this grid. You may choose to enter only part or none of the key field values.


Search Search
Click on this button to search in the topmost table for the entered key field values and return to the topmost table browse window. A message will be displayed if the entered key field values cannot be found in the topmost table.


Search Cancel
Click on this button to cancel the search and return to the topmost table browse window.


Index_AvailableIndexes
This listbox will show the available indexes for the topmost table. You may click on any available index to select it and display the details about the index in the Index Details group box. You may also double-click on any available index to immediately make it the active index and return to the topmost table browse window. Please note that changing the active index will remove any ranges that are active on the topmost table and will re-order the contents of the topmost table browse window according to the new active index.


Index Details
This read-only information shows the fields present in the current selected index in the available indexes list box as well as whether the selected index is descending, case-insensitive, or unique.


Index Select
Click on this button to make the currently selected index the active index and return to the topmost table browse window. Please note that changing the active index will remove any ranges that are active on the topmost table and will re-order the contents of the topmost table browse window according to the new active index.


Index Cancel
Click on this button to cancel changing the active index and return to the topmost table browse window.


Structure Description
Use this edit box to enter the description of the table.


Structure Encrypted
Use this check box to specify whether the table is encrypted. The password edit box is only accessible when the Encrypted check box is checked.


Structure Password
Use this edit box to enter the password for the encrypted table. The password edit box is only accessible when the Encrypted check box is checked, and if a table is encrypted then a password must be entered. The password can be any combination of between 1 and 15 characters and is case-sensitive.


Structure FieldCount
This read-only information shows the number of fields defined in the table.


Structure RecordSize
This read-only information shows the total record size for the table.


Structure BlockSize
Use this edit box to specify the BLOB block size for the table. The BLOB block size can be any size between 64 bytes and 64k bytes.


Structure PrimaryDesc
Use this check box to specify whether the primary index should be descending.


Structure FieldsGrid
This grid shows the field structure information for the table. You may use the UP and DOWN arrow keys to move from field to field. If you move past the last defined field in the grid you will be allowed to add a new field at the end. You may also insert a new field anywhere by pressing the INSERT key. To delete an existing field hold down the CTRL key and press the DELETE key. You will be asked to confirm the field deletion before the field is actually removed. The left-hand side of the grid shows the field number for any given field. You can find out detailed information regarding any field by selecting the desired field and clicking on the Details button available in the Details column on the right hand side of the grid. Clicking on this button will open a dialog with detail information for the currently selected field that can be modified as needed. The information that is shown in this dialog includes the field description, default value, minimum value, maximum value, and character-casing.


Structure Save
Click on this button to save the structure information for the table. If the table is being created then you will be prompted to provide a table name. If the table is being restructured, then a progress dialog will appear indicating the progress of the restructure. If there are any data loss problems due to the restructuring you will be prompted with the appropriate message and the chance to ignore the problems or cancel the restructure process. After the table is created or restructured you will be returned to the main window of the Database System Utility.


Structure Cancel
Click on this button to cancel the table creation (if a new table was being created) or restructure process (if an existing table was being restructured) and return to the main window of the Database System Utility.


Structure FieldDescription
Use this edit box to enter a description for the current field. The description can be any combination of characters between 0 and 50 characters in length.


Structure FieldDefaultValue
Use this edit box to enter a default value for the current field. The default value can be any valid expression for the current field type including the special Now, Date, and Time constants for Date, Time, and Timestamp fields as well as True and False for Boolean fields. Please note that you should not enter either single or double-quotes around string expressions.


Structure FieldMinValue
Use this edit box to enter a minimum value for the current field. The minimum value can be any valid expression for the current field type. Please note that you should not enter either single or double-quotes around string expressions.


Structure FieldMaxValue
Use this edit box to enter a maximum value for the current field. The maximum value can be any valid expression for the current field type. Please note that you should not enter either single or double-quotes around string expressions.


Structure FieldOK
Click on this button to save the detail information for the current field and return to the Structure dialog for the table. If there are any errors in the default value, minimum value, or maximum value expressions you will be notified of them at this point and given a chance to correct them.


Structure FieldCancel
Click on this button to cancel the editing of the detail information for the current field and return to the Structure dialog for the table. Any changes made to the detail information for the current field will be lost.


Structure NumIndexes
This read-only information shows the number of secondary indexes defined for the table.


Structure IndexesGrid
This grid shows the secondary index information for the table. You may use the UP and DOWN arrow keys to move from index to index. If you move past the last defined index in the grid you will be allowed to add a new index at the end. You may also insert a new index anywhere by pressing the INSERT key. To delete an existing secondary index hold down the CTRL key and press the DELETE key. You will be asked to confirm the secondary index deletion before the secondary index is actually removed. The Indexed Fields column can be changed by selecting the desired secondary index and clicking on the button available in the Indexed Fields column. Clicking on this button will open up the Indexed Fields dialog for the selected secondary index and will allow you select what fields should make up the selected secondary index.


Browse Structure MajorVersion
This read-only information shows the user-defined major version # of the table.


Browse Structure MinorVersion
This read-only information shows the user-defined minor version # of the table.


Browse Structure Language
This read-only information shows the language ID of the table.


Browse Structure Sort
This read-only information shows the sort ID of the table.


Structure MajorVersion
Use this edit box to enter the user-defined major version # of the table.


Structure MinorVersion
Use this edit box to enter the user-defined minor version # of the table.


Structure Language
Use this combo box to select the language ID of the table. The language ID will default to the language ID defined as the default for the Database System Utility in the Options dialog.


Structure Sort
Use this combo box to select the sort ID of the table. The sort IDs available are affected by the currently selected language ID, and the sort ID will default to the sort ID defined as the default for the Database System Utility in the Options dialog.


Reverse Language
Use these radio buttons to select the language to use for the generated code. Selecting SQL-92 will result in an .SQL script file being generated, selecting Delphi 3, 4, or 5 will result in a .PAS unit file being generated, and selecting C++Builder 3, 4, or 5 will result in a .CPP file and .H file being generated.


Version Grid
This listbox shows the version information for the table(s) selected. You may use the UP and DOWN arrow keys to move from line to line.


Version_Save
Click on this button to bring forward a standard Windows save dialog that will allow to choose a text file in which to save the version information.


Version Close
Click on this button to close the version information dialog.


Repair LogGrid
This listbox shows the repair log for the table(s) selected. You may use the UP and DOWN arrow keys to move from line to line.


Repair LogSave
Click on this button to bring forward a standard Windows save dialog that will allow to choose a text file in which to save the repair log information.


Repair LogClose
Click on this button to close the repair log dialog.


SQL SQLTab
This page of the SQL browse window shows the actual SQL text for the query and whether the query is live. You can save the SQL text to a text file by selecting the Save SQL To File button or load the SQL text from an existing text file using the Load SQL From File. To run the SQL query specified in the SQL text select the Run SQL button.


SQL BrowseTab
This page of the SQL browse window shows the actual data contents in the query result set. You can select which fields are visible using the Select Visible Fields button.


SQL WantLiveResult
Use this check box to specify whether the SQL query should return a live (editable) result set. Please note that this does not mean that the query result set will actually be live since the query must also adhere to the rules in DBISAM for getting live result sets from queries. Please see the provided DBISAM Online Manual for more information on the rules for live query result sets.


SQL_Load
Click on this button to bring forward a standard Windows open dialog that you may use to select a text file to load an SQL query from. Please note that the SQL query text contained in the file will automatically replace any SQL text currently in the SQL text memo control.


SQL_Save
Click on this button to bring forward a standard Windows save dialog that you may use to select a text file in which to save the SQL query.


SQL Run
Click on this button to run the SQL query. If the SQL contains any errors, then you will receive an appropriate error message indicating where the problem is. If the SQL is correct, then you will be shown the status of the query on the status bar at the bottom of the main window and focus will shift to the Browse Data page when the query is done so that you may view and possibly edit the result set.


SQL Text
Use this memo control to type in the desired SQL text to use for the SQL query. Please note that whitespace and line breaks are permitted as well as comments using the standard /*  and */ SQL comment brackets.


SQL Select Visible
Click on this button to bring forward a dialog that will let you select which fields are visible for the query result set. Please note that all export operations only work on the visible fields, so you can use this option to control which fields are exported.


SQL Grid
This grid shows the contents of the query result set. You can edit or view any memo, graphic, or generic BLOB fields by simply double-clicking on the desired field in the desired record. A memo, graphic, or generic BLOB field contains data if the contents label ("(MEMO)", "(GRAPHIC)", or "(BLOB)") are upper-cased. If the contents label is not upper-cased ("(Memo)", "(Graphic)", or "(Blob)") then the field does not contain any data. The fields that are visible in this grid are controlled by the Select Visible Fields button.


Reverse HardCode
This check box is used to specify whether or not you would like the database directory hard-coded into the generated code. If you do not select this option and are using the Delphi or C++Builder language selections, the generated procedure for creating the tables will contain a parameter for the database directory which can be used to pass different values to the procedure at runtime. If you do not select this option and are using the SQL-92 language selection, the generated script will include no database directory in the script and will rely on the current database directory settings when executing.


Reverse AddData
This check box is used to specify whether or not you would like to have code generated for adding any data that currently exists in the table. Please note that the generated code will contain Null values for any non-memo BLOB fields such as graphics and binary BLOBs.


Options WriteThrough
This check box is used to specify whether or not you would like to force the operating system (Windows 95/98/NT only) to flush all write buffers to disk immediately instead of caching writes and lazily flushing them to disk.


Options Strict Change Detection
This check box is used to specify whether or not you would like to have all tables or queries use strict change detection. Enabling strict change detection causes all tables and queries to automatically use the most up-to-date data, but at a cost in performance. Disabling strict change detection (which is the same as enabling lazy change detection) causes the DBISAM engine to only check for changes whenever it is forced to read from disk, not before every operation. This allows the DBISAM engine to take full advantage of it's built-in caching and results in much better performance, but at a cost in the currency of the data.

Note:   This option only affects reading data, and does not affect updates at all. The DBISAM engine always makes sure that appended and edited records use the most current data.


SQL Save Results
Click on this button to bring forward a standard Windows save dialog that will let you select a table name in which to save the current result set. You can then use the created table as you would any other table.

Note:   You should be careful when using this option since it is very easy to inadvertently overwrite an existing table.


Structure Key Compression
Use this combo box to select the key compression level for the primary index of the table.


Browse Structure Key Compression
This read-only information shows the key compression of the primary index for the table.


Blob Size
This read-only information indicates the size of the current BLOB in bytes.


Clear Blob
Click on this button to clear (delete) the current BLOB contents.


Blob Import
Click on this button to bring forward a standard Windows open dialog that will allow you select a file to import into the current field in the topmost table or query result set.


Blob Export
Click on this button to bring forward a standard Windows save dialog that will allow you select a file to export the current field into.


Blob Close
Click on this button to close the current BLOB dialog and return to the topmost table or query result set browse window.


Browse Copy On Append
Click on this check box if you wish to have the current record's contents copied to any new records that are appended or inserted. This is useful if you need to add several records that are very similar in content.


Browse Suppress AutoInc
Click on this check box if you wish to suppress any auto-increment field when adding or editing a record. This allows you to override the contents of auto-increment fields and is the only way to do so, simply modifying an auto-increment field value will not work unless this check box is checked.


Browse Structure Last AutoInc
This read-only information shows the last auto-increment value used for this table. Any new records containing auto-increment fields will use the next value after the value indicated here.


Browse Character Case
This read-only information shows the character-casing for the currently selected field.


Browse Structure Primary Case
This read-only information shows whether the primary index is case-insensitive.


Options FieldDescriptions
This check box is used to specify whether the field descriptions contained within a table should automatically be used for display in a browse window or live query result window instead of the actual field names.


Options UserPassword
This edit box is used to specify a password for the Database System Utility. If a password is entered, then the Database System Utility will prompt the user for the password and will not allow the user access to the Database System Utility without entering the correct password.


Print ShowDetails
Use this check box to select whether you would like the structure printed to include detailed field information such as field descriptions, default values, min/max values, etc.


Structure Primary Case
Use this check box to specify whether the primary index should be case-insensitive.


Structure Last AutoInc
Use this edit box to specify the last auto-increment value used for this table. Any new records containing auto-increment fields will use the next value after the value indicated here. Please note that this option is only available when restructuring an existing table, not when creating a new table.


Structure FieldCharacterCase
Use these radio buttons to select the the character-casing for the currently selected field.


Structure Borrow
Click on this button to bring forward a standard Windows open dialog that will let you select a table name from which to borrow it's table structure. You can then modify the structure as needed without having to re-enter all of the same information. Please note that borrowing a table structure will overwrite any existing structure information for the table currently being created or restructured.


Structure MoveField
Use these buttons to move the currently selected field up or down in the list of fields in the grid.


Upgrade LogGrid
This listbox shows the upgrade log for the table(s) selected. You may use the UP and DOWN arrow keys to move from line to line.


Upgrade LogSave
Click on this button to bring forward a standard Windows save dialog that will allow to choose a text file in which to save the upgrade log information.


Upgrade LogClose
Click on this button to close the upgrade log dialog.


Optimize_AvailableIndexes
This listbox will show the available indexes for the table currently being optimized. You may click on any available index to select it and display the details about the index in the Index Details group box. You may also double-click on any available index to immediately make it the  index to use for optimizing the current table.


Optimize Details
This read-only information shows the fields present in the current selected index in the available indexes list box as well as whether the selected index is descending, case-insensitive, or unique.


Optimize Select
Click on this button to make the currently selected index the index to use for optimizing the current table.


Optimize Cancel
Click on this button to cancel selecting an index for optimizing the current table and to cancel the entire optimization process.


SQL MaximumRowCount
Use this edit box to indicate the maximum number of rows that will returned in a result set. Please note that this figure does not take into account the ORDER BY, GROUP BY, or HAVING clause when determining the maximum number of rows to include in the result set.


SQL ScriptTab
This page of the SQL browse window allows you to enter and execute SQL scripts. You can save the SQL script text to a text file by selecting the Save SQL Script To File button or load the SQL text from an existing text file using the Load SQL Script From File. To run the SQL script specified in the SQL script text select the Run SQL Script button. Any errors in the script will be displayed as the script is executed and you will be presented with the choice of continuing with the script or aborting the script. Please note that running an SQL script does not in any way interrupt or interfere with any SQL currently being entered or executed on the normal SQL page.


SQL_ScriptLoad
Click on this button to bring forward a standard Windows open dialog that you may use to select a text file to load an SQL script from. Please note that the SQL script text contained in the file will automatically replace any SQL script text currently in the SQL script memo control.


SQL_ScriptSave
Click on this button to bring forward a standard Windows save dialog that you may use to select a text file in which to save the SQL script text.


SQL ScriptRun
Click on this button to run the SQL script. Any errors in the script will be displayed as the script is executed and you will be presented with the choice of continuing with the script or aborting the script. Please note that running an SQL script does not in any way interrupt or interfere with any SQL currently being entered or executed on the normal SQL page.


SQL ScriptText
Use this memo control to type in the desired SQL script text to use for the SQL script. Please note that whitespace and line breaks are permitted as well as comments using the standard /*  and */ SQL comment brackets. Also, if you are entering multiple SQL statements in the script please be sure to include a semicolon (;) after each SQL statement.


SQL CopyOnAppend
Click on this check box if you wish to have the current record's contents copied to any new records that are appended or inserted. This is useful if you need to add several records that are very similar in content.


SQL Suppress AutoInc
Click on this check box if you wish to suppress any auto-increment field when adding or editing a record. This allows you to override the contents of auto-increment fields and is the only way to do so, simply modifying an auto-increment field value will not work unless this check box is checked.


Options Language
Indicates the default language ID to be used for the display of date, time, and numeric data in the Database System Utility as well as the language ID to be used when parsing and interpreting SQL or filter expressions. This language ID will be overriden with the language ID of the active table or query result set if the Override with Table's Language Settings check box is checked (on this page of the Options dialog).


Options Sort
Indicates the default sort ID to be used for the ordering of query result sets in the Database System Utility.


SQL Prepare
Click on this button to prepare the SQL statement. Any errors in the statement will be displayed at this time. If the SQL statement is syntactically correct, then the source tables will be opened at this time and the temporary table for the query result set (if the result set will be canned and not live) will be created on disk.


Configuring System Options

To configure the system options for the Database System Utility please complete the following steps:

1   Select the File option from the main menu

2   Select the Options... option from the File menu

3   This will bring forward the Options dialog

Once the Options dialog is visible you may right-click on any control to receive "What's This" help on that particular area of interest.


Creating a New Table

To create a new table in the Database System Utility please complete the following steps:

1   Select the File option from the main menu

2   Select the New Table... option from the File menu

3   This will bring forward the New Table dialog

Once the New Table dialog is visible you may right-click on any control to receive "What's This" help on that particular area of interest.


Creating a New SQL Query

To create a new SQL query in the Database System Utility please complete the following steps:

1   Select the File option from the main menu

2   Select the New SQL Query... option from the File menu.

3   A new SQL Query window will now open and allow you to type the desired SQL text for the query, run the query, and browse (and possibly edit) the result set. You may also save the SQL text to and from text files from within this window.


Opening an Existing Table

To open an existing table in the Database System Utility please complete the following steps:

1   Select the File option from the main menu

2   If you wish to open a table in Exclusive mode (all other users will be denied access to the table) then you should select the Open Table Exclusive... option from the File menu. If you wish to open a table in Shared mode (all other users will be allowed to open the table also) then you should select the Open Table Shared... option from the File menu.

3   This will bring forward a standard Windows file dialog that will allow you to select the desired table to open and will also let you specify whether the file should be opened for editing or read-only. At this point you may click on the OK button to open the table or click on the Cancel button to cancel opening up a table.

4   After you have selected the desired table to open and clicked on OK in the file dialog you will see the desired table open in a browse window in the Database System Utility. If the table is encrypted you will first be prompted for the password to the table before being allowed to view or edit it's contents. If you do not provide the correct password you will be denied access to the table.


Closing an Open Table

To close an open table in the Database System Utility please complete the following steps:

1   Select the File option from the main menu

2   Select the Close option from the File menu

3   This will close the current (topmost) table browse window and it's associated table.

Note

You can also use the Close All option on the File menu to close all open tables at one time.


Locking Open Table

To lock an open table in the Database System Utility please complete the following steps:

1   Select the Action option from the main menu

2   Select the Lock Table option from the Action menu

Note

No other users can modify the current table when the table is locked. Also, locking the table when the table is opened exclusive does nothing since no other users have access to the table anyways.


Unlocking Open Table

To unlock an open table in the Database System Utility please complete the following steps:

1   Select the Action option from the main menu

2   Select the Unlock Table option from the Action menu


Starting a Transaction

To start a transaction on an open database in the Database System Utility please complete the following steps:

1   Select the database you wish to start the transaction on from the list of open databases in the combo box on the main toolbar

2   Click on the Start Transaction button on the main toolbar to the right of the open databases combo box

Note

DBISAM implements transactions completely in memory and buffers all updates during a transaction. These updates are not written to disk until the transaction is committed, and are discarded if the transaction is rolled back. To accomplish this task, DBISAM must acquire and retain a write lock on all tables in the database involved in the transaction. This write lock is in effect until the transaction is committed or rolled back, and during this time no other users can update (post changes to) the table, although they may both acquire locks and read from the table. This means that you should always keep transactions as short as possible.


Committing a Transaction

To commit a transaction on an open database in the Database System Utility please complete the following steps:

1   Select the database you wish to commit the transaction for from the list of open databases in the combo box on the main toolbar

2   Click on the Commit Transaction button on the main toolbar to the right of the open databases combo box


Rolling Back a Transaction

To rollback a transaction on an open database in the Database System Utility please complete the following steps:

1   Select the database you wish to rollback the transaction for from the list of open databases in the combo box on the main toolbar

2   Click on the Rollback Transaction button on the main toolbar to the right of the open databases combo box


Changing the Active Index Order

To change the active index order on an open table in the Database System Utility please complete the following steps:

1   Select the Action option from the main menu

2   Select the Select Index Order... option from the Action menu

3   This will bring forward the Select Index Order dialog

Once the Select Index Order dialog is visible you may right-click on any control to receive "What's This" help on that particular area of interest.

Note

Changing the active index order will remove any ranges that are active on the current table. Also, since the logical record numbers are based upon the active index order the record number may also change.


Searching for a Record Using the Active Index Order

To search for a record using the active index order on an open table in the Database System Utility please complete the following steps:

1   Select the Action option from the main menu

2   Select the Search for Record Using the Active Index... option from the Action menu

3   This will bring forward the Search For Record Using the Active Index dialog

Once the Search For Record Using the Active Index dialog is visible you may right-click on any control to receive "What's This" help on that particular area of interest.


Finding a Record Using an Expression

To find a record using an expression on an open table in the Database System Utility please complete the following steps:

1   Select the Action option from the main menu

2   Select the Find Record Using Expression... option from the Action menu

3   This will bring forward the Find Record Using an Expression dialog

Once the Find Record Using an Expression dialog is visible you may right-click on any control to receive "What's This" help on that particular area of interest.

Note

Using this option will clear any active filters that have been set for the current open table.


Moving to a Specific Logical Record Number

To move to a specific logical record number in an open table in the Database System Utility please complete the following steps:

1   Select the Action option from the main menu

2   Select the Go to Record... option from the Action menu

3   This will bring forward the Go to Record dialog

Once the Go to Record dialog is visible you may right-click on any control to receive "What's This" help on that particular area of interest.

Note

If the specified logical record number is not found then the record pointer will be positioned on the next closest logical record number.


Setting a Range Using the Active Index Order

To set a range using the active index order on an open table in the Database System Utility please complete the following steps:

1   Select the Action option from the main menu

2   Select the Set a Range... option from the Action menu

3   This will bring forward the Set a Range dialog

Once the Set a Range dialog is visible you may right-click on any control to receive "What's This" help on that particular area of interest.


Setting an Expression Filter

To set an expression filter on an open table in the Database System Utility please complete the following steps:

1   Select the Action option from the main menu

2   Select the Set an Expression Filter... option from the Action menu

3   This will bring forward the Set a Filter dialog

Once the Set a Filter dialog is visible you may right-click on any control to receive "What's This" help on that particular area of interest.


Flushing the Buffers in a Table

To flush the buffers in a table in the Database System Utility please complete the following steps:

1   Select the Action option from the main menu

2   Select the Flush Buffers option from the Action menu

Note

If the table has been opened exclusively then this option causes any dirty DBISAM write buffers to be written to disk and then causes an operating system flush to disk. If the table has been opened shared then this option only causes the operating system flush to disk.


Restructuring Tables

To restructure a table in the Database System Utility please complete the following steps:

1   Select the Utilities option from the main menu

2   Select the Restructure... option from the Utilties menu

3   This will bring forward a standard Windows file dialog that will allow you to select the desired table to restructure. At this point you may click on the OK button to restructure the table or click on the Cancel button to cancel restructuring a table.

4   After you have selected the desired table to restructure and clicked on OK in the file dialog you will see the desired table structure in a Modify Structure dialog. If the table is encrypted you will first be prompted for the password to the table before being allowed to change it's structure. If you do not provide the correct password you will be denied access to the table.

Once the Modify Structure dialog is visible you may right-click on any control to receive "What's This" help on that particular area of interest.


Repairing Corrupted Tables

To repair a corrupted table in the Database System Utility please complete the following steps:

1   Select the Utilities option from the main menu

2   Select the Repair... option from the Utilties menu

3   This will bring forward a standard Windows file dialog that will allow you to select the desired table(s) to repair. You may select multiple tables for repairing by holding down the CTRL key and clicking with the mouse on the tables you wish to repair or by holding down the SHIFT key and clicking on the start and end range of tables you wish to repair. At this point you may click on the OK button to repair the selected table(s) or click on the Cancel button to cancel repairing any tables.

4   After you have selected the desired table(s) to repair and clicked on OK in the file dialog you will see a progress bar display on the status bar at the bottom of the main window.

Once the repair operation is complete you will be notified of the success or failure of the operation and a log of the operation will be displayed in a dialog. You can save this log to a text file by selecting the Save Log to Disk button. Select the Close button in this dialog to complete the repair operation.


Optimizing Tables

To optimize a table in the Database System Utility please complete the following steps:

1   Select the Utilities option from the main menu

2   Select the Optimize... option from the Utilties menu

3   This will bring forward a standard Windows file dialog that will allow you to select the desired table(s) to optimize. You may select multiple tables for repairing by holding down the CTRL key and clicking with the mouse on the tables you wish to optimize or by holding down the SHIFT key and clicking on the start and end range of tables you wish to optimize. At this point you may click on the OK button to optimize the selected table(s) or click on the Cancel button to cancel optimizing any tables.

4   After you have selected the desired table(s) to optimize and clicked on OK in the file dialog you will see a progress bar display on the status bar at the bottom of the main window. As each table is optimized you will be presented with an index selection dialog that will allow you to choose which index (or none if you wish to keep things in natural order and there is no primary index defined) to use for physically aligning the data on disk. This can optimize access quite a bit when navigating the table using the index since it will allow DBISAM to perform large amounts of read-ahead buffering. In addition to this read-ahead optimization, optimizing a table will remove any deleted space from the table and re-order records, index pages, and BLOB blocks in an optimal fashion.

Once the optimize operation is complete you will be notified of the success or failure of the operation and a message dialog will be displayed indicating this.


Emptying Tables

To empty a table in the Database System Utility please complete the following steps:

1   Select the Utilities option from the main menu

2   Select the Empty... option from the Utilties menu

3   This will bring forward a standard Windows file dialog that will allow you to select the desired table(s) to empty. You may select multiple tables for emptying by holding down the CTRL key and clicking with the mouse on the tables you wish to empty or by holding down the SHIFT key and clicking on the start and end range of tables you wish to empty. At this point you may click on the OK button to empty the selected table(s) or click on the Cancel button to cancel emptying any tables.

4   After you have selected the desired table(s) to empty and clicked on OK in the file dialog you will be asked to confirm that you wish to empty the selected table(s). You must click on the Yes button to complete the operation or the No button to cancel emptying any tables.

Once the empty operation is complete you will be notified of the success or failure of the operation.


Copying Tables

To copy a table in the Database System Utility please complete the following steps:

1   Select the Utilities option from the main menu

2   Select the Copy... option from the Utilties menu

3   This will bring forward a standard Windows file dialog that will allow you to select the desired table(s) to copy. You may select multiple tables for copying by holding down the CTRL key and clicking with the mouse on the tables you wish to copy or by holding down the SHIFT key and clicking on the start and end range of tables you wish to copy. At this point you may click on the OK button to copy the selected table(s) or click on the Cancel button to cancel copying any tables.

4   After you have selected the desired table(s) to copy and clicked on OK in the file dialog you will be asked to specify the destination table name for each selected table(s). You must select the destination file from the standard Windows file dialog for each table name and click on the OK button to complete the operation.

Once the copy operation is complete you will be notified of the success or failure of the operation.


Renaming Tables

To rename a table in the Database System Utility please complete the following steps:

1   Select the Utilities option from the main menu

2   Select the Rename... option from the Utilties menu

3   This will bring forward a standard Windows file dialog that will allow you to select the desired table(s) to rename. You may select multiple tables for renaming by holding down the CTRL key and clicking with the mouse on the tables you wish to rename or by holding down the SHIFT key and clicking on the start and end range of tables you wish to rename. At this point you may click on the OK button to renam the selected table(s) or click on the Cancel button to cancel renaming any tables.

4   After you have selected the desired table(s) to rename and clicked on OK in the file dialog you will be asked to specify the destination table name for each selected table(s). You must select the destination file from the standard Windows file dialog for each table name and click on the OK button to complete the operation.

Once the rename operation is complete you will be notified of the success or failure of the operation.


Deleting Tables

To delete a table in the Database System Utility please complete the following steps:

1   Select the Utilities option from the main menu

2   Select the Delete... option from the Utilties menu

3   This will bring forward a standard Windows file dialog that will allow you to select the desired table(s) to delete. You may select multiple tables for deleting by holding down the CTRL key and clicking with the mouse on the tables you wish to delete or by holding down the SHIFT key and clicking on the start and end range of tables you wish to delete. At this point you may click on the OK button to delete the selected table(s) or click on the Cancel button to cancel deleting any tables.

4   After you have selected the desired table(s) to delete and clicked on OK in the file dialog you will be asked to confirm that you wish to delete the selected table(s). You must click on the Yes button to complete the operation or the No button to cancel deleting any tables.

Once the delete operation is complete you will be notified of the success or failure of the operation.


Reverse Engineering Tables

To reverse engineer a table in the Database System Utility please complete the following steps:

1   Select the Utilities option from the main menu

2   Select the Reverse Engineer... option from the Utilties menu

3   This will bring forward the Reverse Engineer options dialog where you can specify any options for the reverse engineer operation. You may right-click on any control to receive help on that particular area of interest. After you have specified the reverse engineer options you may click on the Continue button to continue with the reverse engineer operation or you may click on the Cancel button to cancel the reverse engineer operation.

4   This will bring forward a standard Windows file dialog that will allow you to select the desired table(s) to reverse engineer. You may select multiple tables for reverse engineering by holding down the CTRL key and clicking with the mouse on the tables you wish to reverse engineer or by holding down the SHIFT key and clicking on the start and end range of tables you wish to reverse engineer. At this point you may click on the OK button to continue or click on the Cancel button to cancel reverse engineering any tables.

5   After you have selected the desired table(s) to reverse engineer and clicked on OK in the file dialog you will be prompted with another standard Windows file dialog that will allow you to specify the name of the .SQL (SQL-92 query text file), .PAS (Delphi source file), or .CPP (C++Builder source file) to use for generating the table creation code for the selected table(s). At this point you may click on the OK button to reverse engineer the selected table(s) into the specified source file or click on the Cancel button to cancel reverse engineering any tables.

Once the reverse engineer operation is complete you will be notified of the success or failure of the operation.


Reading Version Information from Tables

To read version information from a table in the Database System Utility please complete the following steps:

1   Select the Utilities option from the main menu

2   Select the Version Information... option from the Utilties menu

3   This will bring forward a standard Windows file dialog that will allow you to select the desired table(s) to read version information from. You may select multiple tables for reading by holding down the CTRL key and clicking with the mouse on the tables you wish to read or by holding down the SHIFT key and clicking on the start and end range of tables you wish to read. At this point you may click on the OK button to read the version information from the selected table(s) or click on the Cancel button to cancel reading any tables.

4   After you have selected the desired table(s) to read version information from and clicked on OK in the file dialog you will see a progress bar display on the status bar at the bottom of the main window.

Once the read operation is complete you will be notified of the success or failure of the operation and a listing of the version information for the selected table(s) will be displayed in a dialog. You can save this listing to a text file by selecting the Save Version Information to Disk button. Select the Close button in this dialog to complete the read operation.


Upgrading Tables

To upgrade a table from a previous DBISAM format version in the Database System Utility please complete the following steps:

1   Select the Utilities option from the main menu

2   Select the Upgrade... option from the Utilties menu

3   This will bring forward a standard Windows file dialog that will allow you to select the desired table(s) to upgrade. You may select multiple tables for upgrading by holding down the CTRL key and clicking with the mouse on the tables you wish to upgrade or by holding down the SHIFT key and clicking on the start and end range of tables you wish to upgrade. At this point you may click on the OK button to upgrade the selected table(s) or click on the Cancel button to cancel upgrading any tables.

4   After you have selected the desired table(s) to upgrade and clicked on OK in the file dialog you will see a progress bar display on the status bar at the bottom of the main window.

Once the upgrade operation is complete you will be notified of the success or failure of the operation and a log of the operation will be displayed in a dialog. You can save this log to a text file by selecting the Save Log to Disk button. Select the Close button in this dialog to complete the upgrade operation.

Note

Attempting to upgrade a table that is already at the most current DBISAM format version will not do any harm at all. You will simply see a message in the log of the upgrade process indicating that the table was already at the most current format version.